<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.*" %><%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2018/3/20
  Time: 23:06
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title></title>
  </head>
  <body>
  这是一个jsp文件
  <br>
  <%
    out.write("hello,world!");
    out.write("<h1>hello,world!</h1>");
  %>


  <style type="text/css">
    table{
      border:1px solid #000;
      border-collapse: collapse;
    }
    td,th{
      border: 1px solid #000000;
      padding: 10px
    }

  </style>

      <table>
      <tr>
      <th>编号</th>
      <th>用户名</th>
      <th>密码</th>
      </tr>

      <tr>
      <td>1</td>
      <td>Jhon</td>
      <td>123</td>
      </tr>
      <tr>
      <td>1</td>
      <td>Jhon</td>
      <td>123</td>
      </tr>
<%
      class User{
      int id;
      String name;
      String password;

      public User(int id, String name, String password) {
      this.id = id;
      this.name = name;
      this.password = password;
      }
      }

      User chen = new User(1,"chengongsuo","123456");
      List<User> list = new ArrayList<User>();
      list.add(new User(1,"chengongsuo","123456"));
      list.add(new User(2,"wuqi","456"));
      list.add(new User(3,"lin","123"));
      list.add(new User(4,"pu","8051323280"));

      //3+1
      Connection connection = null;
      Statement statement = null;
      ResultSet resultSet = null;

      String sql = "select * from t_users ";

      Class.forName("com.mysql.jdbc.Driver");

      connection = DriverManager.getConnection(
      "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC\n",
      "root",
      "199731"
      );

      statement = connection.createStatement();

      resultSet = statement.executeQuery(sql);

      while(resultSet.next()){
      int id = resultSet.getInt(1);
      String username = resultSet.getString(2);
      String password = resultSet.getString(3);

      User user = new User(id,username,password);
      list.add(user);
      }
      statement.close();
      connection.close();
      resultSet.close();

      for (User user :list){
      out.write("<tr>\n" +
      "<td>"+ user.id + "</td>\n" +
      "<td>" + user.name + "</td>\n" +
      "<td>" + user.password + "</td>\n" +
      "</tr>"
      );
      }

  %>
  </table>
  </body>
</html>
